Transmission: A = Automatic AV = Continuously variable
Fuel Type: B = Electricity X = Regular gasoline Z = Premium gasoline (since this is a dataset of Electric vehicles all are B)
Consumption: The combined fuel consumption rating reflects 55 percent city and 45 percent highway driving. 2 Le is gasoline litre equivalent. One litre of gasoline contains the energy equivalent to 8.9 kWh of electricity.
CO2 Emissions: the tailpipe emissions of carbon dioxide (in grams per kilometre) for combined city and highway driving.
CO2 Rating: the tailpipe emissions of carbon dioxide rated on a scale from 1 (worst) to 10 (best).
Smog Rating: the tailpipe emissions of smog-forming pollutants rated on a scale from 1 (worst) to 10 (best).
Range: the estimated driving distance (in kilometres) on a fully charged battery or full tank of fuel.
Recharge time: the estimated time (in hours) to fully recharge the battery at 240 volts
In [1]:
#importing the necessacary packages in python
import matplotlib.pyplot as plt
import pandas as pd
import pylab as pl
import numpy as np
import statsmodels.formula.api as smf
%matplotlib inline
In [2]:
elec = pd.read_csv("fuel consumption dataset\MY2012-2017 Battery Electric Vehicles.csv")
elec.head() #display the column names and sample data
Out[2]:
MODEL
MAKE
MODEL.1
VEHICLE CLASS
MOTOR
TRANSMISSION
FUEL
CONSUMPTION
Unnamed: 8
Unnamed: 9
Unnamed: 10
Unnamed: 11
Unnamed: 12
CO2 EMISSIONS
CO2
SMOG
RANGE
RECHARGE
0
YEAR
NaN
NaN
NaN
(kW)
NaN
TYPE
CITY (kWh/100 km)
HWY (kWh/100 km)
COMB (kWh/100 km)
CITY (Le/100 km)
HWY (Le/100 km)
COMB (Le/100 km)
(g/km)
RATING
RATING
(km)
TIME (h)
1
2012
MITSUBISHI
i-MiEV
SUBCOMPACT
49
A1
B
16.9
21.4
18.7
1.9
2.4
2.1
0
n/a
n/a
100
7
2
2012
NISSAN
LEAF
MID-SIZE
80
A1
B
19.3
23
21.1
2.2
2.6
2.4
0
n/a
n/a
117
7
3
2013
FORD
FOCUS ELECTRIC
COMPACT
107
A1
B
19
21.1
20
2.1
2.4
2.2
0
n/a
n/a
122
4
4
2013
MITSUBISHI
i-MiEV
SUBCOMPACT
49
A1
B
16.9
21.4
18.7
1.9
2.4
2.1
0
n/a
n/a
100
7
In [3]:
cols = [u'MODEL', u'MAKE', u'MODEL.1', u'VEHICLE CLASS', u'FUEL', u'CONSUMPTION', u'Unnamed: 8', u'Unnamed: 9',
u'Unnamed: 10', u'Unnamed: 11', u'Unnamed: 12', u'CO2 EMISSIONS', u'CO2 ', u'SMOG', u'RANGE', u'RECHARGE']
elec=elec[cols] #select only the columns we need
elec
Out[3]:
MODEL
MAKE
MODEL.1
VEHICLE CLASS
FUEL
CONSUMPTION
Unnamed: 8
Unnamed: 9
Unnamed: 10
Unnamed: 11
Unnamed: 12
CO2 EMISSIONS
CO2
SMOG
RANGE
RECHARGE
0
YEAR
NaN
NaN
NaN
TYPE
CITY (kWh/100 km)
HWY (kWh/100 km)
COMB (kWh/100 km)
CITY (Le/100 km)
HWY (Le/100 km)
COMB (Le/100 km)
(g/km)
RATING
RATING
(km)
TIME (h)
1
2012
MITSUBISHI
i-MiEV
SUBCOMPACT
B
16.9
21.4
18.7
1.9
2.4
2.1
0
n/a
n/a
100
7
2
2012
NISSAN
LEAF
MID-SIZE
B
19.3
23
21.1
2.2
2.6
2.4
0
n/a
n/a
117
7
3
2013
FORD
FOCUS ELECTRIC
COMPACT
B
19
21.1
20
2.1
2.4
2.2
0
n/a
n/a
122
4
4
2013
MITSUBISHI
i-MiEV
SUBCOMPACT
B
16.9
21.4
18.7
1.9
2.4
2.1
0
n/a
n/a
100
7
5
2013
NISSAN
LEAF
MID-SIZE
B
19.3
23
21.1
2.2
2.6
2.4
0
n/a
n/a
117
7
6
2013
SMART
FORTWO ELECTRIC DRIVE CABRIOLET
TWO-SEATER
B
17.2
22.5
19.6
1.9
2.5
2.2
0
n/a
n/a
109
8
7
2013
SMART
FORTWO ELECTRIC DRIVE COUPE
TWO-SEATER
B
17.2
22.5
19.6
1.9
2.5
2.2
0
n/a
n/a
109
8
8
2013
TESLA
MODEL S (40 kWh battery)
FULL-SIZE
B
22.4
21.9
22.2
2.5
2.5
2.5
0
n/a
n/a
224
6
9
2013
TESLA
MODEL S (60 kWh battery)
FULL-SIZE
B
22.2
21.7
21.9
2.5
2.4
2.5
0
n/a
n/a
335
10
10
2013
TESLA
MODEL S (85 kWh battery)
FULL-SIZE
B
23.8
23.2
23.6
2.7
2.6
2.6
0
n/a
n/a
426
12
11
2013
TESLA
MODEL S PERFORMANCE
FULL-SIZE
B
23.9
23.2
23.6
2.7
2.6
2.6
0
n/a
n/a
426
12
12
2014
CHEVROLET
SPARK EV
SUBCOMPACT
B
16
19.6
17.8
1.8
2.2
2
0
n/a
n/a
131
7
13
2014
FORD
FOCUS ELECTRIC
COMPACT
B
19
21.1
20
2.1
2.4
2.2
0
n/a
n/a
122
4
14
2014
MITSUBISHI
i-MiEV
SUBCOMPACT
B
16.9
21.4
18.7
1.9
2.4
2.1
0
n/a
n/a
100
7
15
2014
NISSAN
LEAF
MID-SIZE
B
16.5
20.8
18.4
1.9
2.3
2.1
0
n/a
n/a
135
5
16
2014
SMART
FORTWO ELECTRIC DRIVE CABRIOLET
TWO-SEATER
B
17.2
22.5
19.6
1.9
2.5
2.2
0
n/a
n/a
109
8
17
2014
SMART
FORTWO ELECTRIC DRIVE COUPE
TWO-SEATER
B
17.2
22.5
19.6
1.9
2.5
2.2
0
n/a
n/a
109
8
18
2014
TESLA
MODEL S (60 kWh battery)
FULL-SIZE
B
22.2
21.7
21.9
2.5
2.4
2.5
0
n/a
n/a
335
10
19
2014
TESLA
MODEL S (85 kWh battery)
FULL-SIZE
B
23.8
23.2
23.6
2.7
2.6
2.6
0
n/a
n/a
426
12
20
2014
TESLA
MODEL S PERFORMANCE
FULL-SIZE
B
23.9
23.2
23.6
2.7
2.6
2.6
0
n/a
n/a
426
12
21
2015
BMW
i3
SUBCOMPACT
B
15.2
18.8
16.8
1.7
2.1
1.9
0
n/a
n/a
130
4
22
2015
CHEVROLET
SPARK EV
SUBCOMPACT
B
16
19.6
17.8
1.8
2.2
2
0
n/a
n/a
131
7
23
2015
FORD
FOCUS ELECTRIC
COMPACT
B
19
21.1
20
2.1
2.4
2.2
0
n/a
n/a
122
4
24
2015
KIA
SOUL EV
STATION WAGON - SMALL
B
17.5
22.7
19.9
2
2.6
2.2
0
n/a
n/a
149
4
25
2015
MITSUBISHI
i-MiEV
SUBCOMPACT
B
16.9
21.4
18.7
1.9
2.4
2.1
0
n/a
n/a
100
7
26
2015
NISSAN
LEAF
MID-SIZE
B
16.5
20.8
18.4
1.9
2.3
2.1
0
n/a
n/a
135
5
27
2015
SMART
FORTWO ELECTRIC DRIVE CABRIOLET
TWO-SEATER
B
17.2
22.5
19.6
1.9
2.5
2.2
0
n/a
n/a
109
8
28
2015
SMART
FORTWO ELECTRIC DRIVE COUPE
TWO-SEATER
B
17.2
22.5
19.6
1.9
2.5
2.2
0
n/a
n/a
109
8
29
2015
TESLA
MODEL S (60 kWh battery)
FULL-SIZE
B
22.2
21.7
21.9
2.5
2.4
2.5
0
n/a
n/a
335
10
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
54
2016
TESLA
MODEL S P85D/P90D
FULL-SIZE
B
23.4
21.5
22.5
2.6
2.4
2.5
0
10
n/a
407
12
55
2016
TESLA
MODEL S P90D (Refresh)
FULL-SIZE
B
22.9
21
22.1
2.6
2.4
2.5
0
10
n/a
435
12
56
2016
TESLA
MODEL S P100D
FULL-SIZE
B
22.6
20
21.5
2.5
2.3
2.4
0
10
n/a
507
12
57
2016
TESLA
MODEL X 60D
SUV - STANDARD
B
23
22.2
22.6
2.6
2.5
2.5
0
10
n/a
322
10
58
2016
TESLA
MODEL X 75D
SUV - STANDARD
B
23
21.9
22.5
2.6
2.5
2.5
0
10
n/a
383
12
59
2016
TESLA
MODEL X 90D
SUV - STANDARD
B
23.2
22.2
22.7
2.6
2.5
2.6
0
10
n/a
414
12
60
2016
TESLA
MODEL X P90D
SUV - STANDARD
B
23.6
23.3
23.5
2.7
2.6
2.6
0
10
n/a
402
12
61
2016
TESLA
MODEL X P100D
SUV - STANDARD
B
25.7
22.9
24.4
2.9
2.6
2.7
0
10
n/a
465
12
62
2017
BMW
i3 (60 Ah)
SUBCOMPACT
B
15.2
18.8
16.8
1.7
2.1
1.9
0
10
10
130
4
63
2017
BMW
i3 (94 Ah)
SUBCOMPACT
B
16.2
19.7
17.8
1.8
2.2
2
0
10
10
183
5
64
2017
CHEVROLET
BOLT EV
STATION WAGON - SMALL
B
16.4
19
17.6
1.8
2.1
2
0
10
10
383
9.3
65
2017
FORD
FOCUS ELECTRIC
COMPACT
B
17.7
21.8
19.6
2
2.5
2.2
0
10
10
185
5.5
66
2017
KIA
SOUL EV
STATION WAGON - SMALL
B
17.4
23
19.9
2
2.6
2.2
0
10
10
150
4
67
2017
MITSUBISHI
i-MiEV
SUBCOMPACT
B
16.9
20.5
18.7
1.9
2.3
2.1
0
10
10
100
7
68
2017
NISSAN
LEAF
MID-SIZE
B
17
20.7
18.6
1.9
2.3
2.1
0
10
10
172
6
69
2017
TESLA
MODEL S (60 kWh battery)
FULL-SIZE
B
21.5
20.7
21.1
2.4
2.3
2.4
0
10
10
338
10
70
2017
TESLA
MODEL S (75 kWh battery)
FULL-SIZE
B
21.5
21
21.3
2.4
2.4
2.4
0
10
10
401
12
71
2017
TESLA
MODEL S 60D
FULL-SIZE
B
20.6
19.6
20.2
2.3
2.2
2.3
0
10
10
351
10
72
2017
TESLA
MODEL S 75D
FULL-SIZE
B
20.6
19.9
20.3
2.3
2.2
2.3
0
10
10
417
12
73
2017
TESLA
MODEL S 90D
FULL-SIZE
B
20.6
19.7
20.2
2.3
2.2
2.3
0
10
10
473
12
74
2017
TESLA
MODEL S 100D
FULL-SIZE
B
20.7
20.5
20.6
2.3
2.3
2.3
0
10
10
539
12
75
2017
TESLA
MODEL S P90D
FULL-SIZE
B
22.8
20.9
22
2.6
2.3
2.5
0
10
10
435
12
76
2017
TESLA
MODEL S P100D
FULL-SIZE
B
22.6
20
21.5
2.5
2.3
2.4
0
10
10
507
12
77
2017
TESLA
MODEL X 60D
SUV - STANDARD
B
23
22.2
22.6
2.6
2.5
2.5
0
10
10
322
10
78
2017
TESLA
MODEL X 75D
SUV - STANDARD
B
23
21.9
22.5
2.6
2.5
2.5
0
10
10
383
12
79
2017
TESLA
MODEL X 90D
SUV - STANDARD
B
23.2
22.2
22.7
2.6
2.5
2.6
0
10
10
414
12
80
2017
TESLA
MODEL X 100D
SUV - STANDARD
B
24.3
23.7
24
2.7
2.7
2.7
0
10
10
475
12
81
2017
TESLA
MODEL X P90D
SUV - STANDARD
B
23.6
23.3
23.5
2.7
2.6
2.6
0
10
10
402
12
82
2017
TESLA
MODEL X P100D
SUV - STANDARD
B
25.7
22.9
24.4
2.9
2.6
2.7
0
10
10
465
12
83
2017
VOLKSWAGEN
e-GOLF
COMPACT
B
16.8
18.6
17.4
1.9
2.1
2
0
10
10
201
5.3
84 rows × 16 columns
In [4]:
newcols = {'MODEL': 'year', 'MAKE':'make', 'MODEL.1':'model', 'VEHICLE CLASS':'vclass', 'FUEL':'fuel', 'CONSUMPTION':'cityElec', 'Unnamed: 8':'hwyElec', 'Unnamed: 9':'combElec',
'Unnamed: 10':'cityGas', 'Unnamed: 11':'hwyGas', 'Unnamed: 12':'combGas', 'CO2 EMISSIONS':'co2', 'CO2 ':'co2Rate', 'SMOG':'smogRate', 'RANGE':'dist', u'RECHARGE':'recharge'}
elec.rename(columns=newcols, inplace=True)
elec
Out[4]:
year
make
model
vclass
fuel
cityElec
hwyElec
combElec
cityGas
hwyGas
combGas
co2
co2Rate
smogRate
dist
recharge
0
YEAR
NaN
NaN
NaN
TYPE
CITY (kWh/100 km)
HWY (kWh/100 km)
COMB (kWh/100 km)
CITY (Le/100 km)
HWY (Le/100 km)
COMB (Le/100 km)
(g/km)
RATING
RATING
(km)
TIME (h)
1
2012
MITSUBISHI
i-MiEV
SUBCOMPACT
B
16.9
21.4
18.7
1.9
2.4
2.1
0
n/a
n/a
100
7
2
2012
NISSAN
LEAF
MID-SIZE
B
19.3
23
21.1
2.2
2.6
2.4
0
n/a
n/a
117
7
3
2013
FORD
FOCUS ELECTRIC
COMPACT
B
19
21.1
20
2.1
2.4
2.2
0
n/a
n/a
122
4
4
2013
MITSUBISHI
i-MiEV
SUBCOMPACT
B
16.9
21.4
18.7
1.9
2.4
2.1
0
n/a
n/a
100
7
5
2013
NISSAN
LEAF
MID-SIZE
B
19.3
23
21.1
2.2
2.6
2.4
0
n/a
n/a
117
7
6
2013
SMART
FORTWO ELECTRIC DRIVE CABRIOLET
TWO-SEATER
B
17.2
22.5
19.6
1.9
2.5
2.2
0
n/a
n/a
109
8
7
2013
SMART
FORTWO ELECTRIC DRIVE COUPE
TWO-SEATER
B
17.2
22.5
19.6
1.9
2.5
2.2
0
n/a
n/a
109
8
8
2013
TESLA
MODEL S (40 kWh battery)
FULL-SIZE
B
22.4
21.9
22.2
2.5
2.5
2.5
0
n/a
n/a
224
6
9
2013
TESLA
MODEL S (60 kWh battery)
FULL-SIZE
B
22.2
21.7
21.9
2.5
2.4
2.5
0
n/a
n/a
335
10
10
2013
TESLA
MODEL S (85 kWh battery)
FULL-SIZE
B
23.8
23.2
23.6
2.7
2.6
2.6
0
n/a
n/a
426
12
11
2013
TESLA
MODEL S PERFORMANCE
FULL-SIZE
B
23.9
23.2
23.6
2.7
2.6
2.6
0
n/a
n/a
426
12
12
2014
CHEVROLET
SPARK EV
SUBCOMPACT
B
16
19.6
17.8
1.8
2.2
2
0
n/a
n/a
131
7
13
2014
FORD
FOCUS ELECTRIC
COMPACT
B
19
21.1
20
2.1
2.4
2.2
0
n/a
n/a
122
4
14
2014
MITSUBISHI
i-MiEV
SUBCOMPACT
B
16.9
21.4
18.7
1.9
2.4
2.1
0
n/a
n/a
100
7
15
2014
NISSAN
LEAF
MID-SIZE
B
16.5
20.8
18.4
1.9
2.3
2.1
0
n/a
n/a
135
5
16
2014
SMART
FORTWO ELECTRIC DRIVE CABRIOLET
TWO-SEATER
B
17.2
22.5
19.6
1.9
2.5
2.2
0
n/a
n/a
109
8
17
2014
SMART
FORTWO ELECTRIC DRIVE COUPE
TWO-SEATER
B
17.2
22.5
19.6
1.9
2.5
2.2
0
n/a
n/a
109
8
18
2014
TESLA
MODEL S (60 kWh battery)
FULL-SIZE
B
22.2
21.7
21.9
2.5
2.4
2.5
0
n/a
n/a
335
10
19
2014
TESLA
MODEL S (85 kWh battery)
FULL-SIZE
B
23.8
23.2
23.6
2.7
2.6
2.6
0
n/a
n/a
426
12
20
2014
TESLA
MODEL S PERFORMANCE
FULL-SIZE
B
23.9
23.2
23.6
2.7
2.6
2.6
0
n/a
n/a
426
12
21
2015
BMW
i3
SUBCOMPACT
B
15.2
18.8
16.8
1.7
2.1
1.9
0
n/a
n/a
130
4
22
2015
CHEVROLET
SPARK EV
SUBCOMPACT
B
16
19.6
17.8
1.8
2.2
2
0
n/a
n/a
131
7
23
2015
FORD
FOCUS ELECTRIC
COMPACT
B
19
21.1
20
2.1
2.4
2.2
0
n/a
n/a
122
4
24
2015
KIA
SOUL EV
STATION WAGON - SMALL
B
17.5
22.7
19.9
2
2.6
2.2
0
n/a
n/a
149
4
25
2015
MITSUBISHI
i-MiEV
SUBCOMPACT
B
16.9
21.4
18.7
1.9
2.4
2.1
0
n/a
n/a
100
7
26
2015
NISSAN
LEAF
MID-SIZE
B
16.5
20.8
18.4
1.9
2.3
2.1
0
n/a
n/a
135
5
27
2015
SMART
FORTWO ELECTRIC DRIVE CABRIOLET
TWO-SEATER
B
17.2
22.5
19.6
1.9
2.5
2.2
0
n/a
n/a
109
8
28
2015
SMART
FORTWO ELECTRIC DRIVE COUPE
TWO-SEATER
B
17.2
22.5
19.6
1.9
2.5
2.2
0
n/a
n/a
109
8
29
2015
TESLA
MODEL S (60 kWh battery)
FULL-SIZE
B
22.2
21.7
21.9
2.5
2.4
2.5
0
n/a
n/a
335
10
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
54
2016
TESLA
MODEL S P85D/P90D
FULL-SIZE
B
23.4
21.5
22.5
2.6
2.4
2.5
0
10
n/a
407
12
55
2016
TESLA
MODEL S P90D (Refresh)
FULL-SIZE
B
22.9
21
22.1
2.6
2.4
2.5
0
10
n/a
435
12
56
2016
TESLA
MODEL S P100D
FULL-SIZE
B
22.6
20
21.5
2.5
2.3
2.4
0
10
n/a
507
12
57
2016
TESLA
MODEL X 60D
SUV - STANDARD
B
23
22.2
22.6
2.6
2.5
2.5
0
10
n/a
322
10
58
2016
TESLA
MODEL X 75D
SUV - STANDARD
B
23
21.9
22.5
2.6
2.5
2.5
0
10
n/a
383
12
59
2016
TESLA
MODEL X 90D
SUV - STANDARD
B
23.2
22.2
22.7
2.6
2.5
2.6
0
10
n/a
414
12
60
2016
TESLA
MODEL X P90D
SUV - STANDARD
B
23.6
23.3
23.5
2.7
2.6
2.6
0
10
n/a
402
12
61
2016
TESLA
MODEL X P100D
SUV - STANDARD
B
25.7
22.9
24.4
2.9
2.6
2.7
0
10
n/a
465
12
62
2017
BMW
i3 (60 Ah)
SUBCOMPACT
B
15.2
18.8
16.8
1.7
2.1
1.9
0
10
10
130
4
63
2017
BMW
i3 (94 Ah)
SUBCOMPACT
B
16.2
19.7
17.8
1.8
2.2
2
0
10
10
183
5
64
2017
CHEVROLET
BOLT EV
STATION WAGON - SMALL
B
16.4
19
17.6
1.8
2.1
2
0
10
10
383
9.3
65
2017
FORD
FOCUS ELECTRIC
COMPACT
B
17.7
21.8
19.6
2
2.5
2.2
0
10
10
185
5.5
66
2017
KIA
SOUL EV
STATION WAGON - SMALL
B
17.4
23
19.9
2
2.6
2.2
0
10
10
150
4
67
2017
MITSUBISHI
i-MiEV
SUBCOMPACT
B
16.9
20.5
18.7
1.9
2.3
2.1
0
10
10
100
7
68
2017
NISSAN
LEAF
MID-SIZE
B
17
20.7
18.6
1.9
2.3
2.1
0
10
10
172
6
69
2017
TESLA
MODEL S (60 kWh battery)
FULL-SIZE
B
21.5
20.7
21.1
2.4
2.3
2.4
0
10
10
338
10
70
2017
TESLA
MODEL S (75 kWh battery)
FULL-SIZE
B
21.5
21
21.3
2.4
2.4
2.4
0
10
10
401
12
71
2017
TESLA
MODEL S 60D
FULL-SIZE
B
20.6
19.6
20.2
2.3
2.2
2.3
0
10
10
351
10
72
2017
TESLA
MODEL S 75D
FULL-SIZE
B
20.6
19.9
20.3
2.3
2.2
2.3
0
10
10
417
12
73
2017
TESLA
MODEL S 90D
FULL-SIZE
B
20.6
19.7
20.2
2.3
2.2
2.3
0
10
10
473
12
74
2017
TESLA
MODEL S 100D
FULL-SIZE
B
20.7
20.5
20.6
2.3
2.3
2.3
0
10
10
539
12
75
2017
TESLA
MODEL S P90D
FULL-SIZE
B
22.8
20.9
22
2.6
2.3
2.5
0
10
10
435
12
76
2017
TESLA
MODEL S P100D
FULL-SIZE
B
22.6
20
21.5
2.5
2.3
2.4
0
10
10
507
12
77
2017
TESLA
MODEL X 60D
SUV - STANDARD
B
23
22.2
22.6
2.6
2.5
2.5
0
10
10
322
10
78
2017
TESLA
MODEL X 75D
SUV - STANDARD
B
23
21.9
22.5
2.6
2.5
2.5
0
10
10
383
12
79
2017
TESLA
MODEL X 90D
SUV - STANDARD
B
23.2
22.2
22.7
2.6
2.5
2.6
0
10
10
414
12
80
2017
TESLA
MODEL X 100D
SUV - STANDARD
B
24.3
23.7
24
2.7
2.7
2.7
0
10
10
475
12
81
2017
TESLA
MODEL X P90D
SUV - STANDARD
B
23.6
23.3
23.5
2.7
2.6
2.6
0
10
10
402
12
82
2017
TESLA
MODEL X P100D
SUV - STANDARD
B
25.7
22.9
24.4
2.9
2.6
2.7
0
10
10
465
12
83
2017
VOLKSWAGEN
e-GOLF
COMPACT
B
16.8
18.6
17.4
1.9
2.1
2
0
10
10
201
5.3
84 rows × 16 columns
In [5]:
elec = elec.drop(elec.index[0])
elec
Out[5]:
year
make
model
vclass
fuel
cityElec
hwyElec
combElec
cityGas
hwyGas
combGas
co2
co2Rate
smogRate
dist
recharge
1
2012
MITSUBISHI
i-MiEV
SUBCOMPACT
B
16.9
21.4
18.7
1.9
2.4
2.1
0
n/a
n/a
100
7
2
2012
NISSAN
LEAF
MID-SIZE
B
19.3
23
21.1
2.2
2.6
2.4
0
n/a
n/a
117
7
3
2013
FORD
FOCUS ELECTRIC
COMPACT
B
19
21.1
20
2.1
2.4
2.2
0
n/a
n/a
122
4
4
2013
MITSUBISHI
i-MiEV
SUBCOMPACT
B
16.9
21.4
18.7
1.9
2.4
2.1
0
n/a
n/a
100
7
5
2013
NISSAN
LEAF
MID-SIZE
B
19.3
23
21.1
2.2
2.6
2.4
0
n/a
n/a
117
7
6
2013
SMART
FORTWO ELECTRIC DRIVE CABRIOLET
TWO-SEATER
B
17.2
22.5
19.6
1.9
2.5
2.2
0
n/a
n/a
109
8
7
2013
SMART
FORTWO ELECTRIC DRIVE COUPE
TWO-SEATER
B
17.2
22.5
19.6
1.9
2.5
2.2
0
n/a
n/a
109
8
8
2013
TESLA
MODEL S (40 kWh battery)
FULL-SIZE
B
22.4
21.9
22.2
2.5
2.5
2.5
0
n/a
n/a
224
6
9
2013
TESLA
MODEL S (60 kWh battery)
FULL-SIZE
B
22.2
21.7
21.9
2.5
2.4
2.5
0
n/a
n/a
335
10
10
2013
TESLA
MODEL S (85 kWh battery)
FULL-SIZE
B
23.8
23.2
23.6
2.7
2.6
2.6
0
n/a
n/a
426
12
11
2013
TESLA
MODEL S PERFORMANCE
FULL-SIZE
B
23.9
23.2
23.6
2.7
2.6
2.6
0
n/a
n/a
426
12
12
2014
CHEVROLET
SPARK EV
SUBCOMPACT
B
16
19.6
17.8
1.8
2.2
2
0
n/a
n/a
131
7
13
2014
FORD
FOCUS ELECTRIC
COMPACT
B
19
21.1
20
2.1
2.4
2.2
0
n/a
n/a
122
4
14
2014
MITSUBISHI
i-MiEV
SUBCOMPACT
B
16.9
21.4
18.7
1.9
2.4
2.1
0
n/a
n/a
100
7
15
2014
NISSAN
LEAF
MID-SIZE
B
16.5
20.8
18.4
1.9
2.3
2.1
0
n/a
n/a
135
5
16
2014
SMART
FORTWO ELECTRIC DRIVE CABRIOLET
TWO-SEATER
B
17.2
22.5
19.6
1.9
2.5
2.2
0
n/a
n/a
109
8
17
2014
SMART
FORTWO ELECTRIC DRIVE COUPE
TWO-SEATER
B
17.2
22.5
19.6
1.9
2.5
2.2
0
n/a
n/a
109
8
18
2014
TESLA
MODEL S (60 kWh battery)
FULL-SIZE
B
22.2
21.7
21.9
2.5
2.4
2.5
0
n/a
n/a
335
10
19
2014
TESLA
MODEL S (85 kWh battery)
FULL-SIZE
B
23.8
23.2
23.6
2.7
2.6
2.6
0
n/a
n/a
426
12
20
2014
TESLA
MODEL S PERFORMANCE
FULL-SIZE
B
23.9
23.2
23.6
2.7
2.6
2.6
0
n/a
n/a
426
12
21
2015
BMW
i3
SUBCOMPACT
B
15.2
18.8
16.8
1.7
2.1
1.9
0
n/a
n/a
130
4
22
2015
CHEVROLET
SPARK EV
SUBCOMPACT
B
16
19.6
17.8
1.8
2.2
2
0
n/a
n/a
131
7
23
2015
FORD
FOCUS ELECTRIC
COMPACT
B
19
21.1
20
2.1
2.4
2.2
0
n/a
n/a
122
4
24
2015
KIA
SOUL EV
STATION WAGON - SMALL
B
17.5
22.7
19.9
2
2.6
2.2
0
n/a
n/a
149
4
25
2015
MITSUBISHI
i-MiEV
SUBCOMPACT
B
16.9
21.4
18.7
1.9
2.4
2.1
0
n/a
n/a
100
7
26
2015
NISSAN
LEAF
MID-SIZE
B
16.5
20.8
18.4
1.9
2.3
2.1
0
n/a
n/a
135
5
27
2015
SMART
FORTWO ELECTRIC DRIVE CABRIOLET
TWO-SEATER
B
17.2
22.5
19.6
1.9
2.5
2.2
0
n/a
n/a
109
8
28
2015
SMART
FORTWO ELECTRIC DRIVE COUPE
TWO-SEATER
B
17.2
22.5
19.6
1.9
2.5
2.2
0
n/a
n/a
109
8
29
2015
TESLA
MODEL S (60 kWh battery)
FULL-SIZE
B
22.2
21.7
21.9
2.5
2.4
2.5
0
n/a
n/a
335
10
30
2015
TESLA
MODEL S (70 kWh battery)
FULL-SIZE
B
23.8
23.2
23.6
2.7
2.6
2.6
0
n/a
n/a
377
12
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
54
2016
TESLA
MODEL S P85D/P90D
FULL-SIZE
B
23.4
21.5
22.5
2.6
2.4
2.5
0
10
n/a
407
12
55
2016
TESLA
MODEL S P90D (Refresh)
FULL-SIZE
B
22.9
21
22.1
2.6
2.4
2.5
0
10
n/a
435
12
56
2016
TESLA
MODEL S P100D
FULL-SIZE
B
22.6
20
21.5
2.5
2.3
2.4
0
10
n/a
507
12
57
2016
TESLA
MODEL X 60D
SUV - STANDARD
B
23
22.2
22.6
2.6
2.5
2.5
0
10
n/a
322
10
58
2016
TESLA
MODEL X 75D
SUV - STANDARD
B
23
21.9
22.5
2.6
2.5
2.5
0
10
n/a
383
12
59
2016
TESLA
MODEL X 90D
SUV - STANDARD
B
23.2
22.2
22.7
2.6
2.5
2.6
0
10
n/a
414
12
60
2016
TESLA
MODEL X P90D
SUV - STANDARD
B
23.6
23.3
23.5
2.7
2.6
2.6
0
10
n/a
402
12
61
2016
TESLA
MODEL X P100D
SUV - STANDARD
B
25.7
22.9
24.4
2.9
2.6
2.7
0
10
n/a
465
12
62
2017
BMW
i3 (60 Ah)
SUBCOMPACT
B
15.2
18.8
16.8
1.7
2.1
1.9
0
10
10
130
4
63
2017
BMW
i3 (94 Ah)
SUBCOMPACT
B
16.2
19.7
17.8
1.8
2.2
2
0
10
10
183
5
64
2017
CHEVROLET
BOLT EV
STATION WAGON - SMALL
B
16.4
19
17.6
1.8
2.1
2
0
10
10
383
9.3
65
2017
FORD
FOCUS ELECTRIC
COMPACT
B
17.7
21.8
19.6
2
2.5
2.2
0
10
10
185
5.5
66
2017
KIA
SOUL EV
STATION WAGON - SMALL
B
17.4
23
19.9
2
2.6
2.2
0
10
10
150
4
67
2017
MITSUBISHI
i-MiEV
SUBCOMPACT
B
16.9
20.5
18.7
1.9
2.3
2.1
0
10
10
100
7
68
2017
NISSAN
LEAF
MID-SIZE
B
17
20.7
18.6
1.9
2.3
2.1
0
10
10
172
6
69
2017
TESLA
MODEL S (60 kWh battery)
FULL-SIZE
B
21.5
20.7
21.1
2.4
2.3
2.4
0
10
10
338
10
70
2017
TESLA
MODEL S (75 kWh battery)
FULL-SIZE
B
21.5
21
21.3
2.4
2.4
2.4
0
10
10
401
12
71
2017
TESLA
MODEL S 60D
FULL-SIZE
B
20.6
19.6
20.2
2.3
2.2
2.3
0
10
10
351
10
72
2017
TESLA
MODEL S 75D
FULL-SIZE
B
20.6
19.9
20.3
2.3
2.2
2.3
0
10
10
417
12
73
2017
TESLA
MODEL S 90D
FULL-SIZE
B
20.6
19.7
20.2
2.3
2.2
2.3
0
10
10
473
12
74
2017
TESLA
MODEL S 100D
FULL-SIZE
B
20.7
20.5
20.6
2.3
2.3
2.3
0
10
10
539
12
75
2017
TESLA
MODEL S P90D
FULL-SIZE
B
22.8
20.9
22
2.6
2.3
2.5
0
10
10
435
12
76
2017
TESLA
MODEL S P100D
FULL-SIZE
B
22.6
20
21.5
2.5
2.3
2.4
0
10
10
507
12
77
2017
TESLA
MODEL X 60D
SUV - STANDARD
B
23
22.2
22.6
2.6
2.5
2.5
0
10
10
322
10
78
2017
TESLA
MODEL X 75D
SUV - STANDARD
B
23
21.9
22.5
2.6
2.5
2.5
0
10
10
383
12
79
2017
TESLA
MODEL X 90D
SUV - STANDARD
B
23.2
22.2
22.7
2.6
2.5
2.6
0
10
10
414
12
80
2017
TESLA
MODEL X 100D
SUV - STANDARD
B
24.3
23.7
24
2.7
2.7
2.7
0
10
10
475
12
81
2017
TESLA
MODEL X P90D
SUV - STANDARD
B
23.6
23.3
23.5
2.7
2.6
2.6
0
10
10
402
12
82
2017
TESLA
MODEL X P100D
SUV - STANDARD
B
25.7
22.9
24.4
2.9
2.6
2.7
0
10
10
465
12
83
2017
VOLKSWAGEN
e-GOLF
COMPACT
B
16.8
18.6
17.4
1.9
2.1
2
0
10
10
201
5.3
83 rows × 16 columns
In [6]:
elec.describe()
Out[6]:
year
make
model
vclass
fuel
cityElec
hwyElec
combElec
cityGas
hwyGas
combGas
co2
co2Rate
smogRate
dist
recharge
count
83
83
83
83
83
83
83
83
83
83
83
83
83
83
83
83
unique
6
10
40
7
1
32
28
29
12
7
9
1
2
2
33
10
top
2016
TESLA
i-MiEV
FULL-SIZE
B
17.2
22.5
19.6
1.9
2.4
2.2
0
10
n/a
109
12
freq
27
37
6
34
83
8
8
9
20
18
16
83
49
61
8
34
In [7]:
elec.vclass.unique()
Out[7]:
array(['SUBCOMPACT', 'MID-SIZE', 'COMPACT', 'TWO-SEATER', 'FULL-SIZE',
'STATION WAGON - SMALL', 'SUV - STANDARD'], dtype=object)
Understanding the Table for normal cars
Model 4WD/4X4 = Four-wheel drive
AWD = All-wheel drive
CNG = Compressed natural gas
FFV = Flexible-fuel vehicle
NGV = Natural gas vehicle
# = High output engine that provides more power than the standard engine of the same size
Transmission A = Automatic
AM = Automated manual
AS = Automatic with select shift
AV = Continuously variable
M = Manual
3 – 10 = Number of gears
Fuel Type X = Regular gasoline
Z = Premium gasoline
D = Diesel
E = Ethanol (E85)
N = Natural Gas
Fuel Consumption City and highway fuel consumption ratings are shown in litres per 100 kilometres (L/100 km) - combined rating (55% city, 45% hwy) is shown in L/100 km and in miles per imperial gallon (mpg)
CO2 Emissions (g/km) Estimated tailpipe carbon dioxide emissions (in grams per kilometre) are based on fuel type and the combined fuel consumption rating.
In [8]:
df = pd.read_csv("fuel consumption dataset\Original MY2000-2014 Fuel Consumption Ratings (2-cycle).csv")
# take a look at the dataset
df.head()
Out[8]:
MODEL
MAKE
MODEL.1
VEHICLE CLASS
ENGINE SIZE
CYLINDERS
TRANSMISSION
FUEL
FUEL CONSUMPTION
Unnamed: 9
Unnamed: 10
Unnamed: 11
CO2 EMISSIONS
0
2000
ACURA
1.6EL
COMPACT
1.6
4
A4
X
9.2
6.7
8.1
35
186
1
2000
ACURA
1.6EL
COMPACT
1.6
4
M5
X
8.5
6.5
7.6
37
175
2
2000
ACURA
3.2TL
MID-SIZE
3.2
6
AS5
Z
12.2
7.4
10.0
28
230
3
2000
ACURA
3.5RL
MID-SIZE
3.5
6
A4
Z
13.4
9.2
11.5
25
264
4
2000
ACURA
INTEGRA
SUBCOMPACT
1.8
4
A4
X
10.0
7.0
8.6
33
198
In [9]:
df.columns
Out[9]:
Index(['MODEL', 'MAKE', 'MODEL.1', 'VEHICLE CLASS', 'ENGINE SIZE', 'CYLINDERS',
'TRANSMISSION', 'FUEL', 'FUEL CONSUMPTION', 'Unnamed: 9', 'Unnamed: 10',
'Unnamed: 11', 'CO2 EMISSIONS'],
dtype='object')
In [10]:
df.describe()
Out[10]:
MODEL
ENGINE SIZE
CYLINDERS
FUEL CONSUMPTION
Unnamed: 9
Unnamed: 10
Unnamed: 11
CO2 EMISSIONS
count
14339.000000
14339.000000
14339.000000
14339.000000
14339.000000
14339.000000
14339.000000
14339.000000
mean
2007.621382
3.474608
5.989609
12.916347
8.816786
11.073136
27.346189
248.566357
std
4.139629
1.310935
1.776214
3.548003
2.343551
2.975566
7.492087
59.113973
min
2000.000000
0.800000
2.000000
3.500000
3.200000
3.600000
11.000000
83.000000
25%
2004.000000
2.400000
4.000000
10.600000
7.200000
9.100000
22.000000
209.000000
50%
2008.000000
3.400000
6.000000
12.400000
8.300000
10.500000
27.000000
239.000000
75%
2011.000000
4.300000
8.000000
14.900000
10.200000
12.800000
31.000000
285.000000
max
2014.000000
8.400000
16.000000
30.600000
19.000000
24.800000
78.000000
570.000000
In [11]:
cols = ['MODEL','VEHICLE CLASS', 'CO2 EMISSIONS']
df=df[cols]
newcols = {
'MODEL': 'year',
'VEHICLE CLASS':'vclass',
'CO2 EMISSIONS':'co2'}
df.rename(columns=newcols, inplace=True)
df=df.drop(df.index[0])
df = df.reset_index(drop=True)
df
Out[11]:
year
vclass
co2
0
2000
COMPACT
175
1
2000
MID-SIZE
230
2
2000
MID-SIZE
264
3
2000
SUBCOMPACT
198
4
2000
SUBCOMPACT
189
5
2000
SUBCOMPACT
191
6
2000
SUBCOMPACT
267
7
2000
SUBCOMPACT
269
8
2000
COMPACT
218
9
2000
COMPACT
193
10
2000
COMPACT
248
11
2000
COMPACT
225
12
2000
COMPACT
232
13
2000
COMPACT
214
14
2000
COMPACT
255
15
2000
COMPACT
251
16
2000
MID-SIZE
258
17
2000
STATION WAGON - MID-SIZE
269
18
2000
MID-SIZE
264
19
2000
MID-SIZE
267
20
2000
MID-SIZE
269
21
2000
MID-SIZE
260
22
2000
MID-SIZE
269
23
2000
MID-SIZE
269
24
2000
COMPACT
264
25
2000
COMPACT
267
26
2000
MINICOMPACT
225
27
2000
MINICOMPACT
225
28
2000
TWO-SEATER
214
29
2000
TWO-SEATER
225
...
...
...
...
14308
2014
COMPACT
177
14309
2014
COMPACT
177
14310
2014
COMPACT
182
14311
2014
COMPACT
157
14312
2014
COMPACT
157
14313
2014
COMPACT
101
14314
2014
MID-SIZE
168
14315
2014
MID-SIZE
168
14316
2014
MID-SIZE
191
14317
2014
MID-SIZE
196
14318
2014
MID-SIZE
216
14319
2014
MID-SIZE
162
14320
2014
MID-SIZE
154
14321
2014
MINIVAN
242
14322
2014
SUV - SMALL
214
14323
2014
SUV - SMALL
232
14324
2014
SUV - SMALL
214
14325
2014
SUV - STANDARD
246
14326
2014
SUV - STANDARD
243
14327
2014
COMPACT
193
14328
2014
COMPACT
202
14329
2014
COMPACT
230
14330
2014
MID-SIZE
205
14331
2014
MID-SIZE
230
14332
2014
SUV - SMALL
223
14333
2014
SUV - SMALL
237
14334
2014
SUV - SMALL
230
14335
2014
SUV - SMALL
237
14336
2014
SUV - SMALL
225
14337
2014
SUV - STANDARD
258
14338 rows × 3 columns
In [12]:
df['co2'] = df['co2'].astype(float)
df['vclass']=df['vclass'].astype(str)
df['year'] = df['year'].astype(int)
df.describe()
Out[12]:
year
co2
count
14338.000000
14338.000000
mean
2007.621914
248.570721
std
4.139488
59.113725
min
2000.000000
83.000000
25%
2004.000000
209.000000
50%
2008.000000
239.000000
75%
2011.000000
285.000000
max
2014.000000
570.000000
In [13]:
df = df.drop( df[ (df.vclass !='SUBCOMPACT' ) & (df.vclass !='MID-SIZE' ) & (df.vclass !='COMPACT' ) & (df.vclass !='TWO-SEATER' ) & (df.vclass !='FULL-SIZE' ) & (df.vclass !='STATION WAGON - SMALL' ) & (df.vclass !='SUV - STANDARD' )].index )
df.index = range(len(df))
df['vclass'] = df['vclass'].replace('SUBCOMPACT', '1')
df['vclass'] = df['vclass'].replace('MID-SIZE', '2')
df['vclass'] = df['vclass'].replace('COMPACT', '3')
df['vclass'] = df['vclass'].replace('TWO-SEATER', '4')
df['vclass'] = df['vclass'].replace('FULL-SIZE', '5')
df['vclass'] = df['vclass'].replace('STATION WAGON - SMALL', '6')
df['vclass'] = df['vclass'].replace('SUV - STANDARD', '7')
df['vclass'] = df['vclass'].astype(int)
df
Out[13]:
year
vclass
co2
0
2000
3
175.0
1
2000
2
230.0
2
2000
2
264.0
3
2000
1
198.0
4
2000
1
189.0
5
2000
1
191.0
6
2000
1
267.0
7
2000
1
269.0
8
2000
3
218.0
9
2000
3
193.0
10
2000
3
248.0
11
2000
3
225.0
12
2000
3
232.0
13
2000
3
214.0
14
2000
3
255.0
15
2000
3
251.0
16
2000
2
258.0
17
2000
2
264.0
18
2000
2
267.0
19
2000
2
269.0
20
2000
2
260.0
21
2000
2
269.0
22
2000
2
269.0
23
2000
3
264.0
24
2000
3
267.0
25
2000
4
214.0
26
2000
4
225.0
27
2000
3
258.0
28
2000
3
246.0
29
2000
3
237.0
...
...
...
...
7663
2014
3
246.0
7664
2014
1
189.0
7665
2014
6
189.0
7666
2014
6
189.0
7667
2014
6
162.0
7668
2014
6
157.0
7669
2014
3
163.0
7670
2014
3
161.0
7671
2014
3
186.0
7672
2014
3
177.0
7673
2014
3
177.0
7674
2014
3
182.0
7675
2014
3
157.0
7676
2014
3
157.0
7677
2014
3
101.0
7678
2014
2
168.0
7679
2014
2
168.0
7680
2014
2
191.0
7681
2014
2
196.0
7682
2014
2
216.0
7683
2014
2
162.0
7684
2014
2
154.0
7685
2014
7
246.0
7686
2014
7
243.0
7687
2014
3
193.0
7688
2014
3
202.0
7689
2014
3
230.0
7690
2014
2
205.0
7691
2014
2
230.0
7692
2014
7
258.0
7693 rows × 3 columns
In [28]:
model = smf.ols(formula='co2 ~ vclass + year', data=df).fit()
model.paramslm = smf.ols(formula='co2 ~ vclass + year', data=df).fit()
model.params #parameters
Out[28]:
Intercept 3214.660155
vclass 4.951835
year -1.495280
dtype: float64
In [15]:
model.summary()
Out[15]:
OLS Regression Results
Dep. Variable: co2 R-squared: 0.029
Model: OLS Adj. R-squared: 0.028
Method: Least Squares F-statistic: 113.0
Date: Sat, 08 Jul 2017 Prob (F-statistic): 4.30e-49
Time: 19:21:09 Log-Likelihood: -41746.
No. Observations: 7693 AIC: 8.350e+04
Df Residuals: 7690 BIC: 8.352e+04
Df Model: 2
Covariance Type: nonrobust
coef std err t P>|t| [95.0% Conf. Int.]
Intercept 3214.6602 300.499 10.698 0.000 2625.601 3803.720
vclass 4.9518 0.391 12.654 0.000 4.185 5.719
year -1.4953 0.150 -9.985 0.000 -1.789 -1.202
Omnibus: 1590.732 Durbin-Watson: 0.587
Prob(Omnibus): 0.000 Jarque-Bera (JB): 3807.756
Skew: 1.152 Prob(JB): 0.00
Kurtosis: 5.563 Cond. No. 9.62e+05
In [16]:
toPredict = pd.DataFrame({'vclass': [6], 'year':[2000]})
toPredict.head()
Out[16]:
vclass
year
0
6
2000
In [17]:
prediction=model.predict(toPredict)
prediction
Out[17]:
array([ 253.81176846])
So now what we have is basically a cleaned dataset for electric vehicles and the approximate difference in the CO2 that is emitted by a normal vehicle and the CO2 emitted by an electric car (which is nothing)
so the basic flow structure is
inputs:
1. Given by user: make model currentDistance
2. Extracted from database: year vehicle class range consumption recharge time
outputs: The difference in CO2 emitted in kilograms, recharge time) and consumption of fuel
Procedure:
Example:
source: Chelan, Saskatchewan, Canada
destination: Maymont, Saskatchewan, Canada
distance: 353 km
make: TESLA
model: MODEL S P100D
curent distance: 150 km
In [18]:
make="TESLA"
model="MODEL S P100D"
distance=353
curdist=150
res=elec.loc[(elec['make'] == make) & (elec['model'] == model)]
res
Out[18]:
year
make
model
vclass
fuel
cityElec
hwyElec
combElec
cityGas
hwyGas
combGas
co2
co2Rate
smogRate
dist
recharge
56
2016
TESLA
MODEL S P100D
FULL-SIZE
B
22.6
20
21.5
2.5
2.3
2.4
0
10
n/a
507
12
In [19]:
maxdist=res['dist'].astype('int')
maxdist
Out[19]:
56 507
Name: dist, dtype: int32
In [20]:
recharge=res['recharge'].astype('int')
recharge
Out[20]:
56 12
Name: recharge, dtype: int32
In [21]:
year=res['year'].astype('int')
year
Out[21]:
56 2016
Name: year, dtype: int32
In [22]:
res['vclass'] = res['vclass'].replace('SUBCOMPACT', '1')
res['vclass'] = res['vclass'].replace('MID-SIZE', '2')
res['vclass'] = res['vclass'].replace('COMPACT', '3')
res['vclass'] = res['vclass'].replace('TWO-SEATER', '4')
res['vclass'] = res['vclass'].replace('FULL-SIZE', '5')
res['vclass'] = res['vclass'].replace('STATION WAGON - SMALL', '6')
res['vclass'] = res['vclass'].replace('SUV - STANDARD', '7')
vclass = res['vclass'].astype(int)
vclass
C:\Users\Saumya Suvarna\Anaconda3\lib\site-packages\ipykernel\__main__.py:1: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy
if __name__ == '__main__':
C:\Users\Saumya Suvarna\Anaconda3\lib\site-packages\ipykernel\__main__.py:2: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy
from ipykernel import kernelapp as app
C:\Users\Saumya Suvarna\Anaconda3\lib\site-packages\ipykernel\__main__.py:3: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy
app.launch_new_instance()
C:\Users\Saumya Suvarna\Anaconda3\lib\site-packages\ipykernel\__main__.py:4: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy
C:\Users\Saumya Suvarna\Anaconda3\lib\site-packages\ipykernel\__main__.py:5: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy
C:\Users\Saumya Suvarna\Anaconda3\lib\site-packages\ipykernel\__main__.py:6: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy
C:\Users\Saumya Suvarna\Anaconda3\lib\site-packages\ipykernel\__main__.py:7: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy
Out[22]:
56 5
Name: vclass, dtype: int32
In [23]:
combGas=res['combGas'].astype('float')
combGas
Out[23]:
56 2.4
Name: combGas, dtype: float64
In [24]:
combElec=res['combElec'].astype('float')
combElec
Out[24]:
56 21.5
Name: combElec, dtype: float64
In [25]:
if (curdist>distance):
rechargedist=0
rechargetime=0;
flag=0
else:
rechargedist=distance-(curdist-16)
rechargetime=recharge/maxdist*(rechargedist)
flag=1
rechargetime
Out[25]:
56 5.183432
dtype: float64
In [26]:
toPredict = pd.DataFrame({'vclass': vclass, 'year':year})
toPredict.head()
Out[26]:
vclass
year
56
5
2016
In [29]:
prediction=model.predict(toPredict)
prediction #shows co2 emitted in grams per km
Out[29]:
array([ 224.93545828])
In [ ]:
co2=prediction*distance/1000 #in kg
co2
In [ ]:
fuelconsgas=combGas/100*distance
fuelconsgas
In [ ]:
fuelconselec=combElec/100*distance
fuelconselec
In [ ]:
print("The time you need to reacharge your car to make your journey is %f "%rechargetime)
print("The fuel reqired for the journey is %f KWH and in Le is %f"%(fuelconselec,fuelconsgas))
print("Woo hoo you have saved %f kg of CO2 from destroying our earth."%co2)
In [ ]:
import matplotlib.pyplot as plt
import numpy as np
dist=0
curdist=150
x=list()
y=list()
maxdist=507
recharge=12
while dist <1000:
x.append(dist)
if (curdist>dist):
rechargetime=0
else:
#if(dist<maxdist):
rechargedist=dist-(curdist-16)
mul=rechargedist%maxdist
add=int(rechargedist/maxdist)
rechargetime=mul*recharge/maxdist + add*recharge
y.append(rechargetime)
dist+=1;
plt.plot(x,y)
plt.show()
Generating final db
In [50]:
cols=['year','make','model','vclass','fuel','cityElec','hwyElec','combElec','cityGas','hwyGas','combGas','co2','co2Rate','smogRate','dist','recharge','co2saved']
db = pd.DataFrame(columns=cols)
db
Out[50]:
year
make
model
vclass
fuel
cityElec
hwyElec
combElec
cityGas
hwyGas
combGas
co2
co2Rate
smogRate
dist
recharge
co2saved
In [51]:
for index, row in elec.iterrows():
vclass=row["vclass"]
if( vclass == 'SUBCOMPACT'):
vclass=int(1)
elif(vclass =='MID-SIZE'):
vclass=int(2)
elif(vclass =='COMPACT'):
vclass=int(3)
elif(vclass =='TWO-SEATER'):
vclass=int(4)
elif(vclass =='FULL-SIZE'):
vclass=int(5)
elif(vclass =='STATION WAGON - SMALL'):
vclass=int(6)
elif(vclass =='SUV - STANDARD'):
vclass=int(7)
year=int(row["year"])
toPredict = pd.DataFrame({'vclass':[vclass], 'year':[year]})
#print(toPredict.head())
prediction=model.predict(toPredict)
#print(prediction)
dfrow=pd.DataFrame({'year':[year],'make':row["make"],'model':row["model"],'vclass':[vclass],'fuel':row["fuel"],'cityElec':row["cityElec"],'hwyElec':row["hwyElec"],'combElec':row["combElec"],'cityGas':row["cityGas"],'hwyGas':row["hwyGas"],'combGas':row["combGas"],'co2':row["co2"],'co2Rate':row["co2Rate"],'smogRate':row["smogRate"],'dist':row["dist"],'recharge':row["recharge"],'co2saved':prediction})
db = db.append(dfrow)
db
Out[51]:
cityElec
cityGas
co2
co2Rate
co2saved
combElec
combGas
dist
fuel
hwyElec
hwyGas
make
model
recharge
smogRate
vclass
year
0
16.9
1.9
0
n/a
211.109237
18.7
2.1
100
B
21.4
2.4
MITSUBISHI
i-MiEV
7
n/a
1.0
2012.0
0
19.3
2.2
0
n/a
216.061072
21.1
2.4
117
B
23
2.6
NISSAN
LEAF
7
n/a
2.0
2012.0
0
19
2.1
0
n/a
219.517627
20
2.2
122
B
21.1
2.4
FORD
FOCUS ELECTRIC
4
n/a
3.0
2013.0
0
16.9
1.9
0
n/a
209.613957
18.7
2.1
100
B
21.4
2.4
MITSUBISHI
i-MiEV
7
n/a
1.0
2013.0
0
19.3
2.2
0
n/a
214.565792
21.1
2.4
117
B
23
2.6
NISSAN
LEAF
7
n/a
2.0
2013.0
0
17.2
1.9
0
n/a
224.469462
19.6
2.2
109
B
22.5
2.5
SMART
FORTWO ELECTRIC DRIVE CABRIOLET
8
n/a
4.0
2013.0
0
17.2
1.9
0
n/a
224.469462
19.6
2.2
109
B
22.5
2.5
SMART
FORTWO ELECTRIC DRIVE COUPE
8
n/a
4.0
2013.0
0
22.4
2.5
0
n/a
229.421297
22.2
2.5
224
B
21.9
2.5
TESLA
MODEL S (40 kWh battery)
6
n/a
5.0
2013.0
0
22.2
2.5
0
n/a
229.421297
21.9
2.5
335
B
21.7
2.4
TESLA
MODEL S (60 kWh battery)
10
n/a
5.0
2013.0
0
23.8
2.7
0
n/a
229.421297
23.6
2.6
426
B
23.2
2.6
TESLA
MODEL S (85 kWh battery)
12
n/a
5.0
2013.0
0
23.9
2.7
0
n/a
229.421297
23.6
2.6
426
B
23.2
2.6
TESLA
MODEL S PERFORMANCE
12
n/a
5.0
2013.0
0
16
1.8
0
n/a
208.118678
17.8
2
131
B
19.6
2.2
CHEVROLET
SPARK EV
7
n/a
1.0
2014.0
0
19
2.1
0
n/a
218.022348
20
2.2
122
B
21.1
2.4
FORD
FOCUS ELECTRIC
4
n/a
3.0
2014.0
0
16.9
1.9
0
n/a
208.118678
18.7
2.1
100
B
21.4
2.4
MITSUBISHI
i-MiEV
7
n/a
1.0
2014.0
0
16.5
1.9
0
n/a
213.070513
18.4
2.1
135
B
20.8
2.3
NISSAN
LEAF
5
n/a
2.0
2014.0
0
17.2
1.9
0
n/a
222.974183
19.6
2.2
109
B
22.5
2.5
SMART
FORTWO ELECTRIC DRIVE CABRIOLET
8
n/a
4.0
2014.0
0
17.2
1.9
0
n/a
222.974183
19.6
2.2
109
B
22.5
2.5
SMART
FORTWO ELECTRIC DRIVE COUPE
8
n/a
4.0
2014.0
0
22.2
2.5
0
n/a
227.926018
21.9
2.5
335
B
21.7
2.4
TESLA
MODEL S (60 kWh battery)
10
n/a
5.0
2014.0
0
23.8
2.7
0
n/a
227.926018
23.6
2.6
426
B
23.2
2.6
TESLA
MODEL S (85 kWh battery)
12
n/a
5.0
2014.0
0
23.9
2.7
0
n/a
227.926018
23.6
2.6
426
B
23.2
2.6
TESLA
MODEL S PERFORMANCE
12
n/a
5.0
2014.0
0
15.2
1.7
0
n/a
206.623398
16.8
1.9
130
B
18.8
2.1
BMW
i3
4
n/a
1.0
2015.0
0
16
1.8
0
n/a
206.623398
17.8
2
131
B
19.6
2.2
CHEVROLET
SPARK EV
7
n/a
1.0
2015.0
0
19
2.1
0
n/a
216.527068
20
2.2
122
B
21.1
2.4
FORD
FOCUS ELECTRIC
4
n/a
3.0
2015.0
0
17.5
2
0
n/a
231.382573
19.9
2.2
149
B
22.7
2.6
KIA
SOUL EV
4
n/a
6.0
2015.0
0
16.9
1.9
0
n/a
206.623398
18.7
2.1
100
B
21.4
2.4
MITSUBISHI
i-MiEV
7
n/a
1.0
2015.0
0
16.5
1.9
0
n/a
211.575233
18.4
2.1
135
B
20.8
2.3
NISSAN
LEAF
5
n/a
2.0
2015.0
0
17.2
1.9
0
n/a
221.478903
19.6
2.2
109
B
22.5
2.5
SMART
FORTWO ELECTRIC DRIVE CABRIOLET
8
n/a
4.0
2015.0
0
17.2
1.9
0
n/a
221.478903
19.6
2.2
109
B
22.5
2.5
SMART
FORTWO ELECTRIC DRIVE COUPE
8
n/a
4.0
2015.0
0
22.2
2.5
0
n/a
226.430738
21.9
2.5
335
B
21.7
2.4
TESLA
MODEL S (60 kWh battery)
10
n/a
5.0
2015.0
0
23.8
2.7
0
n/a
226.430738
23.6
2.6
377
B
23.2
2.6
TESLA
MODEL S (70 kWh battery)
12
n/a
5.0
2015.0
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
0
23.4
2.6
0
10
224.935458
22.5
2.5
407
B
21.5
2.4
TESLA
MODEL S P85D/P90D
12
n/a
5.0
2016.0
0
22.9
2.6
0
10
224.935458
22.1
2.5
435
B
21
2.4
TESLA
MODEL S P90D (Refresh)
12
n/a
5.0
2016.0
0
22.6
2.5
0
10
224.935458
21.5
2.4
507
B
20
2.3
TESLA
MODEL S P100D
12
n/a
5.0
2016.0
0
23
2.6
0
10
234.839128
22.6
2.5
322
B
22.2
2.5
TESLA
MODEL X 60D
10
n/a
7.0
2016.0
0
23
2.6
0
10
234.839128
22.5
2.5
383
B
21.9
2.5
TESLA
MODEL X 75D
12
n/a
7.0
2016.0
0
23.2
2.6
0
10
234.839128
22.7
2.6
414
B
22.2
2.5
TESLA
MODEL X 90D
12
n/a
7.0
2016.0
0
23.6
2.7
0
10
234.839128
23.5
2.6
402
B
23.3
2.6
TESLA
MODEL X P90D
12
n/a
7.0
2016.0
0
25.7
2.9
0
10
234.839128
24.4
2.7
465
B
22.9
2.6
TESLA
MODEL X P100D
12
n/a
7.0
2016.0
0
15.2
1.7
0
10
203.632839
16.8
1.9
130
B
18.8
2.1
BMW
i3 (60 Ah)
4
10
1.0
2017.0
0
16.2
1.8
0
10
203.632839
17.8
2
183
B
19.7
2.2
BMW
i3 (94 Ah)
5
10
1.0
2017.0
0
16.4
1.8
0
10
228.392014
17.6
2
383
B
19
2.1
CHEVROLET
BOLT EV
9.3
10
6.0
2017.0
0
17.7
2
0
10
213.536509
19.6
2.2
185
B
21.8
2.5
FORD
FOCUS ELECTRIC
5.5
10
3.0
2017.0
0
17.4
2
0
10
228.392014
19.9
2.2
150
B
23
2.6
KIA
SOUL EV
4
10
6.0
2017.0
0
16.9
1.9
0
10
203.632839
18.7
2.1
100
B
20.5
2.3
MITSUBISHI
i-MiEV
7
10
1.0
2017.0
0
17
1.9
0
10
208.584674
18.6
2.1
172
B
20.7
2.3
NISSAN
LEAF
6
10
2.0
2017.0
0
21.5
2.4
0
10
223.440179
21.1
2.4
338
B
20.7
2.3
TESLA
MODEL S (60 kWh battery)
10
10
5.0
2017.0
0
21.5
2.4
0
10
223.440179
21.3
2.4
401
B
21
2.4
TESLA
MODEL S (75 kWh battery)
12
10
5.0
2017.0
0
20.6
2.3
0
10
223.440179
20.2
2.3
351
B
19.6
2.2
TESLA
MODEL S 60D
10
10
5.0
2017.0
0
20.6
2.3
0
10
223.440179
20.3
2.3
417
B
19.9
2.2
TESLA
MODEL S 75D
12
10
5.0
2017.0
0
20.6
2.3
0
10
223.440179
20.2
2.3
473
B
19.7
2.2
TESLA
MODEL S 90D
12
10
5.0
2017.0
0
20.7
2.3
0
10
223.440179
20.6
2.3
539
B
20.5
2.3
TESLA
MODEL S 100D
12
10
5.0
2017.0
0
22.8
2.6
0
10
223.440179
22
2.5
435
B
20.9
2.3
TESLA
MODEL S P90D
12
10
5.0
2017.0
0
22.6
2.5
0
10
223.440179
21.5
2.4
507
B
20
2.3
TESLA
MODEL S P100D
12
10
5.0
2017.0
0
23
2.6
0
10
233.343849
22.6
2.5
322
B
22.2
2.5
TESLA
MODEL X 60D
10
10
7.0
2017.0
0
23
2.6
0
10
233.343849
22.5
2.5
383
B
21.9
2.5
TESLA
MODEL X 75D
12
10
7.0
2017.0
0
23.2
2.6
0
10
233.343849
22.7
2.6
414
B
22.2
2.5
TESLA
MODEL X 90D
12
10
7.0
2017.0
0
24.3
2.7
0
10
233.343849
24
2.7
475
B
23.7
2.7
TESLA
MODEL X 100D
12
10
7.0
2017.0
0
23.6
2.7
0
10
233.343849
23.5
2.6
402
B
23.3
2.6
TESLA
MODEL X P90D
12
10
7.0
2017.0
0
25.7
2.9
0
10
233.343849
24.4
2.7
465
B
22.9
2.6
TESLA
MODEL X P100D
12
10
7.0
2017.0
0
16.8
1.9
0
10
213.536509
17.4
2
201
B
18.6
2.1
VOLKSWAGEN
e-GOLF
5.3
10
3.0
2017.0
83 rows × 17 columns
In [52]:
db=db.reset_index(drop=True)
db
Out[52]:
cityElec
cityGas
co2
co2Rate
co2saved
combElec
combGas
dist
fuel
hwyElec
hwyGas
make
model
recharge
smogRate
vclass
year
0
16.9
1.9
0
n/a
211.109237
18.7
2.1
100
B
21.4
2.4
MITSUBISHI
i-MiEV
7
n/a
1.0
2012.0
1
19.3
2.2
0
n/a
216.061072
21.1
2.4
117
B
23
2.6
NISSAN
LEAF
7
n/a
2.0
2012.0
2
19
2.1
0
n/a
219.517627
20
2.2
122
B
21.1
2.4
FORD
FOCUS ELECTRIC
4
n/a
3.0
2013.0
3
16.9
1.9
0
n/a
209.613957
18.7
2.1
100
B
21.4
2.4
MITSUBISHI
i-MiEV
7
n/a
1.0
2013.0
4
19.3
2.2
0
n/a
214.565792
21.1
2.4
117
B
23
2.6
NISSAN
LEAF
7
n/a
2.0
2013.0
5
17.2
1.9
0
n/a
224.469462
19.6
2.2
109
B
22.5
2.5
SMART
FORTWO ELECTRIC DRIVE CABRIOLET
8
n/a
4.0
2013.0
6
17.2
1.9
0
n/a
224.469462
19.6
2.2
109
B
22.5
2.5
SMART
FORTWO ELECTRIC DRIVE COUPE
8
n/a
4.0
2013.0
7
22.4
2.5
0
n/a
229.421297
22.2
2.5
224
B
21.9
2.5
TESLA
MODEL S (40 kWh battery)
6
n/a
5.0
2013.0
8
22.2
2.5
0
n/a
229.421297
21.9
2.5
335
B
21.7
2.4
TESLA
MODEL S (60 kWh battery)
10
n/a
5.0
2013.0
9
23.8
2.7
0
n/a
229.421297
23.6
2.6
426
B
23.2
2.6
TESLA
MODEL S (85 kWh battery)
12
n/a
5.0
2013.0
10
23.9
2.7
0
n/a
229.421297
23.6
2.6
426
B
23.2
2.6
TESLA
MODEL S PERFORMANCE
12
n/a
5.0
2013.0
11
16
1.8
0
n/a
208.118678
17.8
2
131
B
19.6
2.2
CHEVROLET
SPARK EV
7
n/a
1.0
2014.0
12
19
2.1
0
n/a
218.022348
20
2.2
122
B
21.1
2.4
FORD
FOCUS ELECTRIC
4
n/a
3.0
2014.0
13
16.9
1.9
0
n/a
208.118678
18.7
2.1
100
B
21.4
2.4
MITSUBISHI
i-MiEV
7
n/a
1.0
2014.0
14
16.5
1.9
0
n/a
213.070513
18.4
2.1
135
B
20.8
2.3
NISSAN
LEAF
5
n/a
2.0
2014.0
15
17.2
1.9
0
n/a
222.974183
19.6
2.2
109
B
22.5
2.5
SMART
FORTWO ELECTRIC DRIVE CABRIOLET
8
n/a
4.0
2014.0
16
17.2
1.9
0
n/a
222.974183
19.6
2.2
109
B
22.5
2.5
SMART
FORTWO ELECTRIC DRIVE COUPE
8
n/a
4.0
2014.0
17
22.2
2.5
0
n/a
227.926018
21.9
2.5
335
B
21.7
2.4
TESLA
MODEL S (60 kWh battery)
10
n/a
5.0
2014.0
18
23.8
2.7
0
n/a
227.926018
23.6
2.6
426
B
23.2
2.6
TESLA
MODEL S (85 kWh battery)
12
n/a
5.0
2014.0
19
23.9
2.7
0
n/a
227.926018
23.6
2.6
426
B
23.2
2.6
TESLA
MODEL S PERFORMANCE
12
n/a
5.0
2014.0
20
15.2
1.7
0
n/a
206.623398
16.8
1.9
130
B
18.8
2.1
BMW
i3
4
n/a
1.0
2015.0
21
16
1.8
0
n/a
206.623398
17.8
2
131
B
19.6
2.2
CHEVROLET
SPARK EV
7
n/a
1.0
2015.0
22
19
2.1
0
n/a
216.527068
20
2.2
122
B
21.1
2.4
FORD
FOCUS ELECTRIC
4
n/a
3.0
2015.0
23
17.5
2
0
n/a
231.382573
19.9
2.2
149
B
22.7
2.6
KIA
SOUL EV
4
n/a
6.0
2015.0
24
16.9
1.9
0
n/a
206.623398
18.7
2.1
100
B
21.4
2.4
MITSUBISHI
i-MiEV
7
n/a
1.0
2015.0
25
16.5
1.9
0
n/a
211.575233
18.4
2.1
135
B
20.8
2.3
NISSAN
LEAF
5
n/a
2.0
2015.0
26
17.2
1.9
0
n/a
221.478903
19.6
2.2
109
B
22.5
2.5
SMART
FORTWO ELECTRIC DRIVE CABRIOLET
8
n/a
4.0
2015.0
27
17.2
1.9
0
n/a
221.478903
19.6
2.2
109
B
22.5
2.5
SMART
FORTWO ELECTRIC DRIVE COUPE
8
n/a
4.0
2015.0
28
22.2
2.5
0
n/a
226.430738
21.9
2.5
335
B
21.7
2.4
TESLA
MODEL S (60 kWh battery)
10
n/a
5.0
2015.0
29
23.8
2.7
0
n/a
226.430738
23.6
2.6
377
B
23.2
2.6
TESLA
MODEL S (70 kWh battery)
12
n/a
5.0
2015.0
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
53
23.4
2.6
0
10
224.935458
22.5
2.5
407
B
21.5
2.4
TESLA
MODEL S P85D/P90D
12
n/a
5.0
2016.0
54
22.9
2.6
0
10
224.935458
22.1
2.5
435
B
21
2.4
TESLA
MODEL S P90D (Refresh)
12
n/a
5.0
2016.0
55
22.6
2.5
0
10
224.935458
21.5
2.4
507
B
20
2.3
TESLA
MODEL S P100D
12
n/a
5.0
2016.0
56
23
2.6
0
10
234.839128
22.6
2.5
322
B
22.2
2.5
TESLA
MODEL X 60D
10
n/a
7.0
2016.0
57
23
2.6
0
10
234.839128
22.5
2.5
383
B
21.9
2.5
TESLA
MODEL X 75D
12
n/a
7.0
2016.0
58
23.2
2.6
0
10
234.839128
22.7
2.6
414
B
22.2
2.5
TESLA
MODEL X 90D
12
n/a
7.0
2016.0
59
23.6
2.7
0
10
234.839128
23.5
2.6
402
B
23.3
2.6
TESLA
MODEL X P90D
12
n/a
7.0
2016.0
60
25.7
2.9
0
10
234.839128
24.4
2.7
465
B
22.9
2.6
TESLA
MODEL X P100D
12
n/a
7.0
2016.0
61
15.2
1.7
0
10
203.632839
16.8
1.9
130
B
18.8
2.1
BMW
i3 (60 Ah)
4
10
1.0
2017.0
62
16.2
1.8
0
10
203.632839
17.8
2
183
B
19.7
2.2
BMW
i3 (94 Ah)
5
10
1.0
2017.0
63
16.4
1.8
0
10
228.392014
17.6
2
383
B
19
2.1
CHEVROLET
BOLT EV
9.3
10
6.0
2017.0
64
17.7
2
0
10
213.536509
19.6
2.2
185
B
21.8
2.5
FORD
FOCUS ELECTRIC
5.5
10
3.0
2017.0
65
17.4
2
0
10
228.392014
19.9
2.2
150
B
23
2.6
KIA
SOUL EV
4
10
6.0
2017.0
66
16.9
1.9
0
10
203.632839
18.7
2.1
100
B
20.5
2.3
MITSUBISHI
i-MiEV
7
10
1.0
2017.0
67
17
1.9
0
10
208.584674
18.6
2.1
172
B
20.7
2.3
NISSAN
LEAF
6
10
2.0
2017.0
68
21.5
2.4
0
10
223.440179
21.1
2.4
338
B
20.7
2.3
TESLA
MODEL S (60 kWh battery)
10
10
5.0
2017.0
69
21.5
2.4
0
10
223.440179
21.3
2.4
401
B
21
2.4
TESLA
MODEL S (75 kWh battery)
12
10
5.0
2017.0
70
20.6
2.3
0
10
223.440179
20.2
2.3
351
B
19.6
2.2
TESLA
MODEL S 60D
10
10
5.0
2017.0
71
20.6
2.3
0
10
223.440179
20.3
2.3
417
B
19.9
2.2
TESLA
MODEL S 75D
12
10
5.0
2017.0
72
20.6
2.3
0
10
223.440179
20.2
2.3
473
B
19.7
2.2
TESLA
MODEL S 90D
12
10
5.0
2017.0
73
20.7
2.3
0
10
223.440179
20.6
2.3
539
B
20.5
2.3
TESLA
MODEL S 100D
12
10
5.0
2017.0
74
22.8
2.6
0
10
223.440179
22
2.5
435
B
20.9
2.3
TESLA
MODEL S P90D
12
10
5.0
2017.0
75
22.6
2.5
0
10
223.440179
21.5
2.4
507
B
20
2.3
TESLA
MODEL S P100D
12
10
5.0
2017.0
76
23
2.6
0
10
233.343849
22.6
2.5
322
B
22.2
2.5
TESLA
MODEL X 60D
10
10
7.0
2017.0
77
23
2.6
0
10
233.343849
22.5
2.5
383
B
21.9
2.5
TESLA
MODEL X 75D
12
10
7.0
2017.0
78
23.2
2.6
0
10
233.343849
22.7
2.6
414
B
22.2
2.5
TESLA
MODEL X 90D
12
10
7.0
2017.0
79
24.3
2.7
0
10
233.343849
24
2.7
475
B
23.7
2.7
TESLA
MODEL X 100D
12
10
7.0
2017.0
80
23.6
2.7
0
10
233.343849
23.5
2.6
402
B
23.3
2.6
TESLA
MODEL X P90D
12
10
7.0
2017.0
81
25.7
2.9
0
10
233.343849
24.4
2.7
465
B
22.9
2.6
TESLA
MODEL X P100D
12
10
7.0
2017.0
82
16.8
1.9
0
10
213.536509
17.4
2
201
B
18.6
2.1
VOLKSWAGEN
e-GOLF
5.3
10
3.0
2017.0
83 rows × 17 columns
In [53]:
db.to_csv('Database.csv')
db.to_json('Databasejs.json')
In [56]:
db["vehicle"]=db["make"].astype(str) + " "+db["model"].astype(str)
db
Out[56]:
cityElec
cityGas
co2
co2Rate
co2saved
combElec
combGas
dist
fuel
hwyElec
hwyGas
make
model
recharge
smogRate
vclass
year
vehicle
0
16.9
1.9
0
n/a
211.109237
18.7
2.1
100
B
21.4
2.4
MITSUBISHI
i-MiEV
7
n/a
1.0
2012.0
MITSUBISHI i-MiEV
1
19.3
2.2
0
n/a
216.061072
21.1
2.4
117
B
23
2.6
NISSAN
LEAF
7
n/a
2.0
2012.0
NISSAN LEAF
2
19
2.1
0
n/a
219.517627
20
2.2
122
B
21.1
2.4
FORD
FOCUS ELECTRIC
4
n/a
3.0
2013.0
FORD FOCUS ELECTRIC
3
16.9
1.9
0
n/a
209.613957
18.7
2.1
100
B
21.4
2.4
MITSUBISHI
i-MiEV
7
n/a
1.0
2013.0
MITSUBISHI i-MiEV
4
19.3
2.2
0
n/a
214.565792
21.1
2.4
117
B
23
2.6
NISSAN
LEAF
7
n/a
2.0
2013.0
NISSAN LEAF
5
17.2
1.9
0
n/a
224.469462
19.6
2.2
109
B
22.5
2.5
SMART
FORTWO ELECTRIC DRIVE CABRIOLET
8
n/a
4.0
2013.0
SMART FORTWO ELECTRIC DRIVE CABRIOLET
6
17.2
1.9
0
n/a
224.469462
19.6
2.2
109
B
22.5
2.5
SMART
FORTWO ELECTRIC DRIVE COUPE
8
n/a
4.0
2013.0
SMART FORTWO ELECTRIC DRIVE COUPE
7
22.4
2.5
0
n/a
229.421297
22.2
2.5
224
B
21.9
2.5
TESLA
MODEL S (40 kWh battery)
6
n/a
5.0
2013.0
TESLA MODEL S (40 kWh battery)
8
22.2
2.5
0
n/a
229.421297
21.9
2.5
335
B
21.7
2.4
TESLA
MODEL S (60 kWh battery)
10
n/a
5.0
2013.0
TESLA MODEL S (60 kWh battery)
9
23.8
2.7
0
n/a
229.421297
23.6
2.6
426
B
23.2
2.6
TESLA
MODEL S (85 kWh battery)
12
n/a
5.0
2013.0
TESLA MODEL S (85 kWh battery)
10
23.9
2.7
0
n/a
229.421297
23.6
2.6
426
B
23.2
2.6
TESLA
MODEL S PERFORMANCE
12
n/a
5.0
2013.0
TESLA MODEL S PERFORMANCE
11
16
1.8
0
n/a
208.118678
17.8
2
131
B
19.6
2.2
CHEVROLET
SPARK EV
7
n/a
1.0
2014.0
CHEVROLET SPARK EV
12
19
2.1
0
n/a
218.022348
20
2.2
122
B
21.1
2.4
FORD
FOCUS ELECTRIC
4
n/a
3.0
2014.0
FORD FOCUS ELECTRIC
13
16.9
1.9
0
n/a
208.118678
18.7
2.1
100
B
21.4
2.4
MITSUBISHI
i-MiEV
7
n/a
1.0
2014.0
MITSUBISHI i-MiEV
14
16.5
1.9
0
n/a
213.070513
18.4
2.1
135
B
20.8
2.3
NISSAN
LEAF
5
n/a
2.0
2014.0
NISSAN LEAF
15
17.2
1.9
0
n/a
222.974183
19.6
2.2
109
B
22.5
2.5
SMART
FORTWO ELECTRIC DRIVE CABRIOLET
8
n/a
4.0
2014.0
SMART FORTWO ELECTRIC DRIVE CABRIOLET
16
17.2
1.9
0
n/a
222.974183
19.6
2.2
109
B
22.5
2.5
SMART
FORTWO ELECTRIC DRIVE COUPE
8
n/a
4.0
2014.0
SMART FORTWO ELECTRIC DRIVE COUPE
17
22.2
2.5
0
n/a
227.926018
21.9
2.5
335
B
21.7
2.4
TESLA
MODEL S (60 kWh battery)
10
n/a
5.0
2014.0
TESLA MODEL S (60 kWh battery)
18
23.8
2.7
0
n/a
227.926018
23.6
2.6
426
B
23.2
2.6
TESLA
MODEL S (85 kWh battery)
12
n/a
5.0
2014.0
TESLA MODEL S (85 kWh battery)
19
23.9
2.7
0
n/a
227.926018
23.6
2.6
426
B
23.2
2.6
TESLA
MODEL S PERFORMANCE
12
n/a
5.0
2014.0
TESLA MODEL S PERFORMANCE
20
15.2
1.7
0
n/a
206.623398
16.8
1.9
130
B
18.8
2.1
BMW
i3
4
n/a
1.0
2015.0
BMW i3
21
16
1.8
0
n/a
206.623398
17.8
2
131
B
19.6
2.2
CHEVROLET
SPARK EV
7
n/a
1.0
2015.0
CHEVROLET SPARK EV
22
19
2.1
0
n/a
216.527068
20
2.2
122
B
21.1
2.4
FORD
FOCUS ELECTRIC
4
n/a
3.0
2015.0
FORD FOCUS ELECTRIC
23
17.5
2
0
n/a
231.382573
19.9
2.2
149
B
22.7
2.6
KIA
SOUL EV
4
n/a
6.0
2015.0
KIA SOUL EV
24
16.9
1.9
0
n/a
206.623398
18.7
2.1
100
B
21.4
2.4
MITSUBISHI
i-MiEV
7
n/a
1.0
2015.0
MITSUBISHI i-MiEV
25
16.5
1.9
0
n/a
211.575233
18.4
2.1
135
B
20.8
2.3
NISSAN
LEAF
5
n/a
2.0
2015.0
NISSAN LEAF
26
17.2
1.9
0
n/a
221.478903
19.6
2.2
109
B
22.5
2.5
SMART
FORTWO ELECTRIC DRIVE CABRIOLET
8
n/a
4.0
2015.0
SMART FORTWO ELECTRIC DRIVE CABRIOLET
27
17.2
1.9
0
n/a
221.478903
19.6
2.2
109
B
22.5
2.5
SMART
FORTWO ELECTRIC DRIVE COUPE
8
n/a
4.0
2015.0
SMART FORTWO ELECTRIC DRIVE COUPE
28
22.2
2.5
0
n/a
226.430738
21.9
2.5
335
B
21.7
2.4
TESLA
MODEL S (60 kWh battery)
10
n/a
5.0
2015.0
TESLA MODEL S (60 kWh battery)
29
23.8
2.7
0
n/a
226.430738
23.6
2.6
377
B
23.2
2.6
TESLA
MODEL S (70 kWh battery)
12
n/a
5.0
2015.0
TESLA MODEL S (70 kWh battery)
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
53
23.4
2.6
0
10
224.935458
22.5
2.5
407
B
21.5
2.4
TESLA
MODEL S P85D/P90D
12
n/a
5.0
2016.0
TESLA MODEL S P85D/P90D
54
22.9
2.6
0
10
224.935458
22.1
2.5
435
B
21
2.4
TESLA
MODEL S P90D (Refresh)
12
n/a
5.0
2016.0
TESLA MODEL S P90D (Refresh)
55
22.6
2.5
0
10
224.935458
21.5
2.4
507
B
20
2.3
TESLA
MODEL S P100D
12
n/a
5.0
2016.0
TESLA MODEL S P100D
56
23
2.6
0
10
234.839128
22.6
2.5
322
B
22.2
2.5
TESLA
MODEL X 60D
10
n/a
7.0
2016.0
TESLA MODEL X 60D
57
23
2.6
0
10
234.839128
22.5
2.5
383
B
21.9
2.5
TESLA
MODEL X 75D
12
n/a
7.0
2016.0
TESLA MODEL X 75D
58
23.2
2.6
0
10
234.839128
22.7
2.6
414
B
22.2
2.5
TESLA
MODEL X 90D
12
n/a
7.0
2016.0
TESLA MODEL X 90D
59
23.6
2.7
0
10
234.839128
23.5
2.6
402
B
23.3
2.6
TESLA
MODEL X P90D
12
n/a
7.0
2016.0
TESLA MODEL X P90D
60
25.7
2.9
0
10
234.839128
24.4
2.7
465
B
22.9
2.6
TESLA
MODEL X P100D
12
n/a
7.0
2016.0
TESLA MODEL X P100D
61
15.2
1.7
0
10
203.632839
16.8
1.9
130
B
18.8
2.1
BMW
i3 (60 Ah)
4
10
1.0
2017.0
BMW i3 (60 Ah)
62
16.2
1.8
0
10
203.632839
17.8
2
183
B
19.7
2.2
BMW
i3 (94 Ah)
5
10
1.0
2017.0
BMW i3 (94 Ah)
63
16.4
1.8
0
10
228.392014
17.6
2
383
B
19
2.1
CHEVROLET
BOLT EV
9.3
10
6.0
2017.0
CHEVROLET BOLT EV
64
17.7
2
0
10
213.536509
19.6
2.2
185
B
21.8
2.5
FORD
FOCUS ELECTRIC
5.5
10
3.0
2017.0
FORD FOCUS ELECTRIC
65
17.4
2
0
10
228.392014
19.9
2.2
150
B
23
2.6
KIA
SOUL EV
4
10
6.0
2017.0
KIA SOUL EV
66
16.9
1.9
0
10
203.632839
18.7
2.1
100
B
20.5
2.3
MITSUBISHI
i-MiEV
7
10
1.0
2017.0
MITSUBISHI i-MiEV
67
17
1.9
0
10
208.584674
18.6
2.1
172
B
20.7
2.3
NISSAN
LEAF
6
10
2.0
2017.0
NISSAN LEAF
68
21.5
2.4
0
10
223.440179
21.1
2.4
338
B
20.7
2.3
TESLA
MODEL S (60 kWh battery)
10
10
5.0
2017.0
TESLA MODEL S (60 kWh battery)
69
21.5
2.4
0
10
223.440179
21.3
2.4
401
B
21
2.4
TESLA
MODEL S (75 kWh battery)
12
10
5.0
2017.0
TESLA MODEL S (75 kWh battery)
70
20.6
2.3
0
10
223.440179
20.2
2.3
351
B
19.6
2.2
TESLA
MODEL S 60D
10
10
5.0
2017.0
TESLA MODEL S 60D
71
20.6
2.3
0
10
223.440179
20.3
2.3
417
B
19.9
2.2
TESLA
MODEL S 75D
12
10
5.0
2017.0
TESLA MODEL S 75D
72
20.6
2.3
0
10
223.440179
20.2
2.3
473
B
19.7
2.2
TESLA
MODEL S 90D
12
10
5.0
2017.0
TESLA MODEL S 90D
73
20.7
2.3
0
10
223.440179
20.6
2.3
539
B
20.5
2.3
TESLA
MODEL S 100D
12
10
5.0
2017.0
TESLA MODEL S 100D
74
22.8
2.6
0
10
223.440179
22
2.5
435
B
20.9
2.3
TESLA
MODEL S P90D
12
10
5.0
2017.0
TESLA MODEL S P90D
75
22.6
2.5
0
10
223.440179
21.5
2.4
507
B
20
2.3
TESLA
MODEL S P100D
12
10
5.0
2017.0
TESLA MODEL S P100D
76
23
2.6
0
10
233.343849
22.6
2.5
322
B
22.2
2.5
TESLA
MODEL X 60D
10
10
7.0
2017.0
TESLA MODEL X 60D
77
23
2.6
0
10
233.343849
22.5
2.5
383
B
21.9
2.5
TESLA
MODEL X 75D
12
10
7.0
2017.0
TESLA MODEL X 75D
78
23.2
2.6
0
10
233.343849
22.7
2.6
414
B
22.2
2.5
TESLA
MODEL X 90D
12
10
7.0
2017.0
TESLA MODEL X 90D
79
24.3
2.7
0
10
233.343849
24
2.7
475
B
23.7
2.7
TESLA
MODEL X 100D
12
10
7.0
2017.0
TESLA MODEL X 100D
80
23.6
2.7
0
10
233.343849
23.5
2.6
402
B
23.3
2.6
TESLA
MODEL X P90D
12
10
7.0
2017.0
TESLA MODEL X P90D
81
25.7
2.9
0
10
233.343849
24.4
2.7
465
B
22.9
2.6
TESLA
MODEL X P100D
12
10
7.0
2017.0
TESLA MODEL X P100D
82
16.8
1.9
0
10
213.536509
17.4
2
201
B
18.6
2.1
VOLKSWAGEN
e-GOLF
5.3
10
3.0
2017.0
VOLKSWAGEN e-GOLF
83 rows × 18 columns
In [57]:
db.drop(["make","model"],inplace=True,axis=1)
db
Out[57]:
cityElec
cityGas
co2
co2Rate
co2saved
combElec
combGas
dist
fuel
hwyElec
hwyGas
recharge
smogRate
vclass
year
vehicle
0
16.9
1.9
0
n/a
211.109237
18.7
2.1
100
B
21.4
2.4
7
n/a
1.0
2012.0
MITSUBISHI i-MiEV
1
19.3
2.2
0
n/a
216.061072
21.1
2.4
117
B
23
2.6
7
n/a
2.0
2012.0
NISSAN LEAF
2
19
2.1
0
n/a
219.517627
20
2.2
122
B
21.1
2.4
4
n/a
3.0
2013.0
FORD FOCUS ELECTRIC
3
16.9
1.9
0
n/a
209.613957
18.7
2.1
100
B
21.4
2.4
7
n/a
1.0
2013.0
MITSUBISHI i-MiEV
4
19.3
2.2
0
n/a
214.565792
21.1
2.4
117
B
23
2.6
7
n/a
2.0
2013.0
NISSAN LEAF
5
17.2
1.9
0
n/a
224.469462
19.6
2.2
109
B
22.5
2.5
8
n/a
4.0
2013.0
SMART FORTWO ELECTRIC DRIVE CABRIOLET
6
17.2
1.9
0
n/a
224.469462
19.6
2.2
109
B
22.5
2.5
8
n/a
4.0
2013.0
SMART FORTWO ELECTRIC DRIVE COUPE
7
22.4
2.5
0
n/a
229.421297
22.2
2.5
224
B
21.9
2.5
6
n/a
5.0
2013.0
TESLA MODEL S (40 kWh battery)
8
22.2
2.5
0
n/a
229.421297
21.9
2.5
335
B
21.7
2.4
10
n/a
5.0
2013.0
TESLA MODEL S (60 kWh battery)
9
23.8
2.7
0
n/a
229.421297
23.6
2.6
426
B
23.2
2.6
12
n/a
5.0
2013.0
TESLA MODEL S (85 kWh battery)
10
23.9
2.7
0
n/a
229.421297
23.6
2.6
426
B
23.2
2.6
12
n/a
5.0
2013.0
TESLA MODEL S PERFORMANCE
11
16
1.8
0
n/a
208.118678
17.8
2
131
B
19.6
2.2
7
n/a
1.0
2014.0
CHEVROLET SPARK EV
12
19
2.1
0
n/a
218.022348
20
2.2
122
B
21.1
2.4
4
n/a
3.0
2014.0
FORD FOCUS ELECTRIC
13
16.9
1.9
0
n/a
208.118678
18.7
2.1
100
B
21.4
2.4
7
n/a
1.0
2014.0
MITSUBISHI i-MiEV
14
16.5
1.9
0
n/a
213.070513
18.4
2.1
135
B
20.8
2.3
5
n/a
2.0
2014.0
NISSAN LEAF
15
17.2
1.9
0
n/a
222.974183
19.6
2.2
109
B
22.5
2.5
8
n/a
4.0
2014.0
SMART FORTWO ELECTRIC DRIVE CABRIOLET
16
17.2
1.9
0
n/a
222.974183
19.6
2.2
109
B
22.5
2.5
8
n/a
4.0
2014.0
SMART FORTWO ELECTRIC DRIVE COUPE
17
22.2
2.5
0
n/a
227.926018
21.9
2.5
335
B
21.7
2.4
10
n/a
5.0
2014.0
TESLA MODEL S (60 kWh battery)
18
23.8
2.7
0
n/a
227.926018
23.6
2.6
426
B
23.2
2.6
12
n/a
5.0
2014.0
TESLA MODEL S (85 kWh battery)
19
23.9
2.7
0
n/a
227.926018
23.6
2.6
426
B
23.2
2.6
12
n/a
5.0
2014.0
TESLA MODEL S PERFORMANCE
20
15.2
1.7
0
n/a
206.623398
16.8
1.9
130
B
18.8
2.1
4
n/a
1.0
2015.0
BMW i3
21
16
1.8
0
n/a
206.623398
17.8
2
131
B
19.6
2.2
7
n/a
1.0
2015.0
CHEVROLET SPARK EV
22
19
2.1
0
n/a
216.527068
20
2.2
122
B
21.1
2.4
4
n/a
3.0
2015.0
FORD FOCUS ELECTRIC
23
17.5
2
0
n/a
231.382573
19.9
2.2
149
B
22.7
2.6
4
n/a
6.0
2015.0
KIA SOUL EV
24
16.9
1.9
0
n/a
206.623398
18.7
2.1
100
B
21.4
2.4
7
n/a
1.0
2015.0
MITSUBISHI i-MiEV
25
16.5
1.9
0
n/a
211.575233
18.4
2.1
135
B
20.8
2.3
5
n/a
2.0
2015.0
NISSAN LEAF
26
17.2
1.9
0
n/a
221.478903
19.6
2.2
109
B
22.5
2.5
8
n/a
4.0
2015.0
SMART FORTWO ELECTRIC DRIVE CABRIOLET
27
17.2
1.9
0
n/a
221.478903
19.6
2.2
109
B
22.5
2.5
8
n/a
4.0
2015.0
SMART FORTWO ELECTRIC DRIVE COUPE
28
22.2
2.5
0
n/a
226.430738
21.9
2.5
335
B
21.7
2.4
10
n/a
5.0
2015.0
TESLA MODEL S (60 kWh battery)
29
23.8
2.7
0
n/a
226.430738
23.6
2.6
377
B
23.2
2.6
12
n/a
5.0
2015.0
TESLA MODEL S (70 kWh battery)
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
53
23.4
2.6
0
10
224.935458
22.5
2.5
407
B
21.5
2.4
12
n/a
5.0
2016.0
TESLA MODEL S P85D/P90D
54
22.9
2.6
0
10
224.935458
22.1
2.5
435
B
21
2.4
12
n/a
5.0
2016.0
TESLA MODEL S P90D (Refresh)
55
22.6
2.5
0
10
224.935458
21.5
2.4
507
B
20
2.3
12
n/a
5.0
2016.0
TESLA MODEL S P100D
56
23
2.6
0
10
234.839128
22.6
2.5
322
B
22.2
2.5
10
n/a
7.0
2016.0
TESLA MODEL X 60D
57
23
2.6
0
10
234.839128
22.5
2.5
383
B
21.9
2.5
12
n/a
7.0
2016.0
TESLA MODEL X 75D
58
23.2
2.6
0
10
234.839128
22.7
2.6
414
B
22.2
2.5
12
n/a
7.0
2016.0
TESLA MODEL X 90D
59
23.6
2.7
0
10
234.839128
23.5
2.6
402
B
23.3
2.6
12
n/a
7.0
2016.0
TESLA MODEL X P90D
60
25.7
2.9
0
10
234.839128
24.4
2.7
465
B
22.9
2.6
12
n/a
7.0
2016.0
TESLA MODEL X P100D
61
15.2
1.7
0
10
203.632839
16.8
1.9
130
B
18.8
2.1
4
10
1.0
2017.0
BMW i3 (60 Ah)
62
16.2
1.8
0
10
203.632839
17.8
2
183
B
19.7
2.2
5
10
1.0
2017.0
BMW i3 (94 Ah)
63
16.4
1.8
0
10
228.392014
17.6
2
383
B
19
2.1
9.3
10
6.0
2017.0
CHEVROLET BOLT EV
64
17.7
2
0
10
213.536509
19.6
2.2
185
B
21.8
2.5
5.5
10
3.0
2017.0
FORD FOCUS ELECTRIC
65
17.4
2
0
10
228.392014
19.9
2.2
150
B
23
2.6
4
10
6.0
2017.0
KIA SOUL EV
66
16.9
1.9
0
10
203.632839
18.7
2.1
100
B
20.5
2.3
7
10
1.0
2017.0
MITSUBISHI i-MiEV
67
17
1.9
0
10
208.584674
18.6
2.1
172
B
20.7
2.3
6
10
2.0
2017.0
NISSAN LEAF
68
21.5
2.4
0
10
223.440179
21.1
2.4
338
B
20.7
2.3
10
10
5.0
2017.0
TESLA MODEL S (60 kWh battery)
69
21.5
2.4
0
10
223.440179
21.3
2.4
401
B
21
2.4
12
10
5.0
2017.0
TESLA MODEL S (75 kWh battery)
70
20.6
2.3
0
10
223.440179
20.2
2.3
351
B
19.6
2.2
10
10
5.0
2017.0
TESLA MODEL S 60D
71
20.6
2.3
0
10
223.440179
20.3
2.3
417
B
19.9
2.2
12
10
5.0
2017.0
TESLA MODEL S 75D
72
20.6
2.3
0
10
223.440179
20.2
2.3
473
B
19.7
2.2
12
10
5.0
2017.0
TESLA MODEL S 90D
73
20.7
2.3
0
10
223.440179
20.6
2.3
539
B
20.5
2.3
12
10
5.0
2017.0
TESLA MODEL S 100D
74
22.8
2.6
0
10
223.440179
22
2.5
435
B
20.9
2.3
12
10
5.0
2017.0
TESLA MODEL S P90D
75
22.6
2.5
0
10
223.440179
21.5
2.4
507
B
20
2.3
12
10
5.0
2017.0
TESLA MODEL S P100D
76
23
2.6
0
10
233.343849
22.6
2.5
322
B
22.2
2.5
10
10
7.0
2017.0
TESLA MODEL X 60D
77
23
2.6
0
10
233.343849
22.5
2.5
383
B
21.9
2.5
12
10
7.0
2017.0
TESLA MODEL X 75D
78
23.2
2.6
0
10
233.343849
22.7
2.6
414
B
22.2
2.5
12
10
7.0
2017.0
TESLA MODEL X 90D
79
24.3
2.7
0
10
233.343849
24
2.7
475
B
23.7
2.7
12
10
7.0
2017.0
TESLA MODEL X 100D
80
23.6
2.7
0
10
233.343849
23.5
2.6
402
B
23.3
2.6
12
10
7.0
2017.0
TESLA MODEL X P90D
81
25.7
2.9
0
10
233.343849
24.4
2.7
465
B
22.9
2.6
12
10
7.0
2017.0
TESLA MODEL X P100D
82
16.8
1.9
0
10
213.536509
17.4
2
201
B
18.6
2.1
5.3
10
3.0
2017.0
VOLKSWAGEN e-GOLF
83 rows × 16 columns
In [58]:
db.to_csv('Database.csv')
db.to_json('Databasejs.json')
Content source: Saumya-Suvarna/machine-learning
Similar notebooks: